A Formal OLAP Algebra for NoSQL based Data Warehouses
نویسندگان
چکیده
NoSQL solutions are started to be increasingly used in modern days’ Data Warehouses (DW). However, business analysts face challenges when performing On Line Analytical Processing (OLAP) queries on these systems. The lack of uniform representation various OLAP operations over different types based DWs is one them. In addition, deficiency precise semantics create obstacles effective query interpretation distinct DWs. This paper aiming deal with aforementioned challenges. Formal and rigorous specification represented this for kinds operators operations. These specifications capable analyse queries. Further, the proposed formal implemented a document-oriented database using suitable case study. approach aids efficient visualization techniques data cubes
منابع مشابه
A Formal Algebra for OLAP
Online Analytical Processing (OLAP) comprises tools and algorithms that allow querying multidimensional databases. It is based on the multidimensional model, where data can be seen as a cube, where each cell contains one or more measures can be aggregated along dimensions. Despite the extensive corpus of work in the field, a standard language for OLAP is still needed, since there is no well-def...
متن کاملA Formal Algebra for OLAP Link
Online Analytical Processing (OLAP) comprises tools and algorithms that allow querying multidimensional databases. It is based on the multidimensional model, where data can be seen as a cube, where each cell contains one or more measures can be aggregated along dimensions. Despite the extensive corpus of work in the field, a standard language for OLAP is still needed, since there is no well-def...
متن کاملOLAP Query Processing for Partitioned Data Warehouses
On-line analytical processing (OLAP) queries can take hours or even days to execute on very large data warehouses. Therefore, there is a need to employ techniques that can facilitate efficient execution of these queries. Data partitioning concept that has been studied in the context of relational databases aims to reduce query execution time and facilitate the parallel execution of queries. In ...
متن کاملImplementing Multidimensional Data Warehouses into NoSQL
Not only SQL (NoSQL) databases are becoming increasingly popular and have some interesting strengths such as scalability and flexibility. In this paper, we investigate on the use of NoSQL systems for implementing OLAP (On-Line Analytical Processing) systems. More precisely, we are interested in instantiating OLAP systems (from the conceptual level to the logical level) and instantiating an aggr...
متن کاملTowards a Novel OLAP Interface for Distributed Data Warehouses
We present a framework for visualizing remote distributed data sources using a multi-user immersive virtual reality environment. DIVE-ON is a system prototype that consolidates distributed data sources into a multidimensional data model, transports user-specified views to a 3D immersive display, and presents various data attributes and mining results as virtual objects in true 3D interactive vi...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Annals of emerging technologies in computing.
سال: 2021
ISSN: ['2516-0281', '2516-029X']
DOI: https://doi.org/10.33166/aetic.2021.05.019